Ignite Data Profiling

Dataset statistics

Number of variables	16
Number of observations	1000
Missing cells	1270
Missing cells (%)	7.9%
Duplicate rows	0
Duplicate rows (%)	0.0%
Total size in memory	527.2 KiB
Average record size in memory	539.9 B

Variable types

DateTime	1
Categorical	7
Numeric	8

Alerts

`source` has constant value "Offline"	Constant
`adstock_alpha` is highly overall correlated with `c0` and 4 other fields	High correlation
`c0` is highly overall correlated with `adstock_alpha` and 4 other fields	High correlation
`c1` is highly overall correlated with `adstock_alpha` and 4 other fields	High correlation
`c2` is highly overall correlated with `adstock_alpha` and 4 other fields	High correlation
`c3` is highly overall correlated with `adstock_alpha` and 4 other fields	High correlation
`carryover_contribution` is highly overall correlated with `imme_contribution` and 2 other fields	High correlation
`factors` is highly overall correlated with `adstock_alpha` and 4 other fields	High correlation
`imme_contribution` is highly overall correlated with `carryover_contribution` and 2 other fields	High correlation
`spend` is highly overall correlated with `carryover_contribution` and 2 other fields	High correlation
`total_contribution` is highly overall correlated with `carryover_contribution` and 2 other fields	High correlation
`spend` has 45 (4.5%) missing values	Missing
`adstock_alpha` has 245 (24.5%) missing values	Missing
`imme_contribution` has 245 (24.5%) missing values	Missing
`carryover_contribution` has 245 (24.5%) missing values	Missing
`saturation_lam` has 245 (24.5%) missing values	Missing
`saturation_beta` has 245 (24.5%) missing values	Missing
`total_contribution` has 167 (16.7%) zeros	Zeros
`spend` has 252 (25.2%) zeros	Zeros
`imme_contribution` has 150 (15.0%) zeros	Zeros
`carryover_contribution` has 150 (15.0%) zeros	Zeros

Reproduction

Analysis started	2026-01-27 03:55:59.388506
Analysis finished	2026-01-27 03:56:07.464687
Duration	8.08 seconds
Software version	ydata-profiling v0.0.dev0
Download configuration	config.json

date
Date

Distinct	52
Distinct (%)	5.2%
Missing	0
Missing (%)	0.0%
Memory size	15.6 KiB

Minimum	2021-01-01 00:00:00
Maximum	2025-04-01 00:00:00

Histogram

Histogram with fixed size bins (bins=50)

factors
Categorical

HIGH CORRELATION

Distinct	49
Distinct (%)	4.9%
Missing	0
Missing (%)	0.0%
Memory size	83.0 KiB

atl_ip_spend	30
ec_tmall_livestream_spend	26
atl_dy_kos_spend	25
atl_dy_kos_feeds_spend	25
atl_ott_spend	25
Other values (44)	869

Length

Max length	33
Median length	28
Mean length	20.039
Min length	9

Characters and Unicode

Total characters	20039
Distinct characters	28
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	atl_dy_kol_feeds_spend
2nd row	atl_dy_kos_feeds_spend
3rd row	ctrl_top5_market_share_std
4th row	atl_dy_kos_spend
5th row	ec_dy_expert_live_spend

Common Values

Value	Count	Frequency (%)
atl_ip_spend	30	3.0%
ec_tmall_livestream_spend	26	2.6%
atl_dy_kos_spend	25	2.5%
atl_dy_kos_feeds_spend	25	2.5%
atl_ott_spend	25	2.5%
ec_dy_expert_live_spend	24	2.4%
ddt_exhibition_spend	24	2.4%
ctrl_own_brand_npd_std	24	2.4%
intercept	24	2.4%
tmkt_pg_st_spend	23	2.3%
Other values (39)	750	75.0%

Length

Histogram of lengths of the category

Value	Count	Frequency (%)
atl_ip_spend	30	3.0%
ec_tmall_livestream_spend	26	2.6%
atl_dy_kos_spend	25	2.5%
atl_dy_kos_feeds_spend	25	2.5%
atl_ott_spend	25	2.5%
ec_dy_expert_live_spend	24	2.4%
ddt_exhibition_spend	24	2.4%
ctrl_own_brand_npd_std	24	2.4%
intercept	24	2.4%
ec_tmall_cps_spend	23	2.3%
Other values (39)	750	75.0%

Most occurring characters

Value	Count	Frequency (%)
_	3001	15.0%
t	1966	9.8%
d	1795	9.0%
e	1784	8.9%
s	1657	8.3%
p	1321	6.6%
n	1309	6.5%
l	1057	5.3%
a	975	4.9%
o	842	4.2%
Other values (18)	4332	21.6%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	20039	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
_	3001	15.0%
t	1966	9.8%
d	1795	9.0%
e	1784	8.9%
s	1657	8.3%
p	1321	6.6%
n	1309	6.5%
l	1057	5.3%
a	975	4.9%
o	842	4.2%
Other values (18)	4332	21.6%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	20039	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
_	3001	15.0%
t	1966	9.8%
d	1795	9.0%
e	1784	8.9%
s	1657	8.3%
p	1321	6.6%
n	1309	6.5%
l	1057	5.3%
a	975	4.9%
o	842	4.2%
Other values (18)	4332	21.6%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	20039	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
_	3001	15.0%
t	1966	9.8%
d	1795	9.0%
e	1784	8.9%
s	1657	8.3%
p	1321	6.6%
n	1309	6.5%
l	1057	5.3%
a	975	4.9%
o	842	4.2%
Other values (18)	4332	21.6%

total_contribution
Real number (ℝ)

HIGH CORRELATION ZEROS

Distinct	805
Distinct (%)	80.5%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	1291978.3

Minimum	-6880378.7
Maximum	41734464
Zeros	167
Zeros (%)	16.7%
Negative	50
Negative (%)	5.0%
Memory size	15.6 KiB

Quantile statistics

Minimum	-6880378.7
5-th percentile	-1271.0002
Q1	4231.3844
median	121367.68
Q3	408496.07
95-th percentile	3506398
Maximum	41734464
Range	48614842
Interquartile range (IQR)	404264.69

Descriptive statistics

Standard deviation	6166852.8
Coefficient of variation (CV)	4.773186
Kurtosis	35.041757
Mean	1291978.3
Median Absolute Deviation (MAD)	121367.68
Skewness	5.9886654
Sum	1.2919783 × 10⁹
Variance	3.8030073 × 10¹³
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	167	16.7%
220406.3033	9	0.9%
-258506.7076	4	0.4%
-3817697.712	3	0.3%
-988279.1761	3	0.3%
3506397.999	3	0.3%
-1016875.217	2	0.2%
-2264068.03	2	0.2%
1047439.291	2	0.2%
1088442.252	2	0.2%
Other values (795)	803	80.3%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
-6880378.72	2	0.2%
-3817697.712	3	0.3%
-3103940.543	1	0.1%
-2980744.464	1	0.1%
-2438619.815	1	0.1%
-2311851.83	2	0.2%
-2264068.03	2	0.2%
-2084918.077	1	0.1%
-2043232.269	1	0.1%
-1860163.728	1	0.1%

Value	Count	Frequency (%)
41734463.53	1	0.1%
41728475.09	1	0.1%
41601776.73	1	0.1%
41454682.92	1	0.1%
41402253.32	1	0.1%
41379899.64	1	0.1%
41178298.33	1	0.1%
41072843.54	1	0.1%
41039024.48	1	0.1%
40984459.86	1	0.1%

spend
Real number (ℝ)

HIGH CORRELATION MISSING ZEROS

Distinct	671
Distinct (%)	70.3%
Missing	45
Missing (%)	4.5%
Infinite	0
Infinite (%)	0.0%
Mean	359264.06

Minimum	0
Maximum	4324718
Zeros	252
Zeros (%)	25.2%
Negative	0
Negative (%)	0.0%
Memory size	15.6 KiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	0
median	53340.897
Q3	453858.91
95-th percentile	1674901
Maximum	4324718
Range	4324718
Interquartile range (IQR)	453858.91

Descriptive statistics

Standard deviation	605209.91
Coefficient of variation (CV)	1.6845824
Kurtosis	6.9498735
Mean	359264.06
Median Absolute Deviation (MAD)	53340.897
Skewness	2.4341402
Sum	3.4309717 × 10⁸
Variance	3.6627903 × 10¹¹
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	252	25.2%
0.7986954913	9	0.9%
1	7	0.7%
0.1094601802	4	0.4%
0.6803149606	3	0.3%
785700	3	0.3%
94340	2	0.2%
1504200	2	0.2%
1067150	2	0.2%
0.7	2	0.2%
Other values (661)	669	66.9%
(Missing)	45	4.5%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	252	25.2%
0.01076365943	1	0.1%
0.1015533991	1	0.1%
0.1094601802	4	0.4%
0.1160676895	1	0.1%
0.1340448826	1	0.1%
0.1396153015	1	0.1%
0.1421610411	1	0.1%
0.1980116706	1	0.1%
0.2926734385	1	0.1%

Value	Count	Frequency (%)
4324718	1	0.1%
3882306	1	0.1%
3436807	1	0.1%
3225204.705	1	0.1%
3064597.434	1	0.1%
2963543.301	1	0.1%
2919383.468	1	0.1%
2823394.988	1	0.1%
2752941.88	1	0.1%
2752238	1	0.1%

year
Categorical

Distinct	5
Distinct (%)	0.5%
Missing	0
Missing (%)	0.0%
Memory size	67.4 KiB

2022	237
2021	231
2024	230
2023	222
2025	80

Length

Max length	4
Median length	4
Mean length	4
Min length	4

Characters and Unicode

Total characters	4000
Distinct characters	6
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	2021
2nd row	2024
3rd row	2021
4th row	2023
5th row	2023

Common Values

Value	Count	Frequency (%)
2022	237	23.7%
2021	231	23.1%
2024	230	23.0%
2023	222	22.2%
2025	80	8.0%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
2022	237	23.7%
2021	231	23.1%
2024	230	23.0%
2023	222	22.2%
2025	80	8.0%

Most occurring characters

Value	Count	Frequency (%)
2	2237	55.9%
0	1000	25.0%
1	231	5.8%
4	230	5.8%
3	222	5.5%
5	80	2.0%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	4000	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
2	2237	55.9%
0	1000	25.0%
1	231	5.8%
4	230	5.8%
3	222	5.5%
5	80	2.0%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	4000	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
2	2237	55.9%
0	1000	25.0%
1	231	5.8%
4	230	5.8%
3	222	5.5%
5	80	2.0%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	4000	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
2	2237	55.9%
0	1000	25.0%
1	231	5.8%
4	230	5.8%
3	222	5.5%
5	80	2.0%

month
Real number (ℝ)

Distinct	12
Distinct (%)	1.2%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	6.247

Minimum	1
Maximum	12
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	15.6 KiB

Quantile statistics

Minimum	1
5-th percentile	1
Q1	3
median	6
Q3	9
95-th percentile	12
Maximum	12
Range	11
Interquartile range (IQR)	6

Descriptive statistics

Standard deviation	3.4371216
Coefficient of variation (CV)	0.55020355
Kurtosis	-1.1999291
Mean	6.247
Median Absolute Deviation (MAD)	3
Skewness	0.10213124
Sum	6247
Variance	11.813805
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=12)

Value	Count	Frequency (%)
2	96	9.6%
4	95	9.5%
3	91	9.1%
7	88	8.8%
1	87	8.7%
6	84	8.4%
8	81	8.1%
9	79	7.9%
5	76	7.6%
12	76	7.6%
Other values (2)	147	14.7%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
1	87	8.7%
2	96	9.6%
3	91	9.1%
4	95	9.5%
5	76	7.6%
6	84	8.4%
7	88	8.8%
8	81	8.1%
9	79	7.9%
10	73	7.3%

Value	Count	Frequency (%)
12	76	7.6%
11	74	7.4%
10	73	7.3%
9	79	7.9%
8	81	8.1%
7	88	8.8%
6	84	8.4%
5	76	7.6%
4	95	9.5%
3	91	9.1%

source
Categorical

CONSTANT

Distinct	1
Distinct (%)	0.1%
Missing	0
Missing (%)	0.0%
Memory size	70.3 KiB

Offline	1000

Length

Max length	7
Median length	7
Mean length	7
Min length	7

Characters and Unicode

Total characters	7000
Distinct characters	6
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	Offline
2nd row	Offline
3rd row	Offline
4th row	Offline
5th row	Offline

Common Values

Value	Count	Frequency (%)
Offline	1000	100.0%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
offline	1000	100.0%

Most occurring characters

Value	Count	Frequency (%)
f	2000	28.6%
O	1000	14.3%
l	1000	14.3%
i	1000	14.3%
n	1000	14.3%
e	1000	14.3%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	7000	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
f	2000	28.6%
O	1000	14.3%
l	1000	14.3%
i	1000	14.3%
n	1000	14.3%
e	1000	14.3%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	7000	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
f	2000	28.6%
O	1000	14.3%
l	1000	14.3%
i	1000	14.3%
n	1000	14.3%
e	1000	14.3%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	7000	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
f	2000	28.6%
O	1000	14.3%
l	1000	14.3%
i	1000	14.3%
n	1000	14.3%
e	1000	14.3%

c0
Categorical

HIGH CORRELATION

Distinct	2
Distinct (%)	0.2%
Missing	0
Missing (%)	0.0%
Memory size	71.6 KiB

Offline	737
base_Offline	263

Length

Max length	12
Median length	7
Mean length	8.315
Min length	7

Characters and Unicode

Total characters	8315
Distinct characters	10
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	Offline
2nd row	Offline
3rd row	base_Offline
4th row	Offline
5th row	Offline

Common Values

Value	Count	Frequency (%)
Offline	737	73.7%
base_Offline	263	26.3%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
offline	737	73.7%
base_offline	263	26.3%

Most occurring characters

Value	Count	Frequency (%)
f	2000	24.1%
e	1263	15.2%
O	1000	12.0%
l	1000	12.0%
i	1000	12.0%
n	1000	12.0%
b	263	3.2%
a	263	3.2%
s	263	3.2%
_	263	3.2%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	8315	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
f	2000	24.1%
e	1263	15.2%
O	1000	12.0%
l	1000	12.0%
i	1000	12.0%
n	1000	12.0%
b	263	3.2%
a	263	3.2%
s	263	3.2%
_	263	3.2%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	8315	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
f	2000	24.1%
e	1263	15.2%
O	1000	12.0%
l	1000	12.0%
i	1000	12.0%
n	1000	12.0%
b	263	3.2%
a	263	3.2%
s	263	3.2%
_	263	3.2%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	8315	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
f	2000	24.1%
e	1263	15.2%
O	1000	12.0%
l	1000	12.0%
i	1000	12.0%
n	1000	12.0%
b	263	3.2%
a	263	3.2%
s	263	3.2%
_	263	3.2%

c1
Categorical

HIGH CORRELATION

Distinct	5
Distinct (%)	0.5%
Missing	0
Missing (%)	0.0%
Memory size	66.5 KiB

ATL	279
Base	263
EC	222
DDT	141
TMKT	95

Length

Max length	4
Median length	3
Mean length	3.136
Min length	2

Characters and Unicode

Total characters	3136
Distinct characters	12
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	ATL
2nd row	ATL
3rd row	Base
4th row	ATL
5th row	EC

Common Values

Value	Count	Frequency (%)
ATL	279	27.9%
Base	263	26.3%
EC	222	22.2%
DDT	141	14.1%
TMKT	95	9.5%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
atl	279	27.9%
base	263	26.3%
ec	222	22.2%
ddt	141	14.1%
tmkt	95	9.5%

Most occurring characters

Value	Count	Frequency (%)
T	610	19.5%
D	282	9.0%
A	279	8.9%
L	279	8.9%
B	263	8.4%
a	263	8.4%
s	263	8.4%
e	263	8.4%
E	222	7.1%
C	222	7.1%
Other values (2)	190	6.1%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	3136	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
T	610	19.5%
D	282	9.0%
A	279	8.9%
L	279	8.9%
B	263	8.4%
a	263	8.4%
s	263	8.4%
e	263	8.4%
E	222	7.1%
C	222	7.1%
Other values (2)	190	6.1%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	3136	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
T	610	19.5%
D	282	9.0%
A	279	8.9%
L	279	8.9%
B	263	8.4%
a	263	8.4%
s	263	8.4%
e	263	8.4%
E	222	7.1%
C	222	7.1%
Other values (2)	190	6.1%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	3136	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
T	610	19.5%
D	282	9.0%
A	279	8.9%
L	279	8.9%
B	263	8.4%
a	263	8.4%
s	263	8.4%
e	263	8.4%
E	222	7.1%
C	222	7.1%
Other values (2)	190	6.1%

c2
Categorical

HIGH CORRELATION

Distinct	7
Distinct (%)	0.7%
Missing	0
Missing (%)	0.0%
Memory size	67.6 KiB

ATL	279
EC	222
control	218
DDT	141
TMKT	95
Other values (2)	45

Length

Max length	18
Median length	9
Mean length	4.204
Min length	2

Characters and Unicode

Total characters	4204
Distinct characters	21
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	ATL
2nd row	ATL
3rd row	control
4th row	ATL
5th row	EC

Common Values

Value	Count	Frequency (%)
ATL	279	27.9%
EC	222	22.2%
control	218	21.8%
DDT	141	14.1%
TMKT	95	9.5%
intercept	24	2.4%
yearly_seasonality	21	2.1%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
atl	279	27.9%
ec	222	22.2%
control	218	21.8%
ddt	141	14.1%
tmkt	95	9.5%
intercept	24	2.4%
yearly_seasonality	21	2.1%

Most occurring characters

Value	Count	Frequency (%)
T	610	14.5%
o	457	10.9%
t	287	6.8%
D	282	6.7%
A	279	6.6%
L	279	6.6%
r	263	6.3%
n	263	6.3%
l	260	6.2%
c	242	5.8%
Other values (11)	982	23.4%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	4204	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
T	610	14.5%
o	457	10.9%
t	287	6.8%
D	282	6.7%
A	279	6.6%
L	279	6.6%
r	263	6.3%
n	263	6.3%
l	260	6.2%
c	242	5.8%
Other values (11)	982	23.4%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	4204	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
T	610	14.5%
o	457	10.9%
t	287	6.8%
D	282	6.7%
A	279	6.6%
L	279	6.6%
r	263	6.3%
n	263	6.3%
l	260	6.2%
c	242	5.8%
Other values (11)	982	23.4%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	4204	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
T	610	14.5%
o	457	10.9%
t	287	6.8%
D	282	6.7%
A	279	6.6%
L	279	6.6%
r	263	6.3%
n	263	6.3%
l	260	6.2%
c	242	5.8%
Other values (11)	982	23.4%

c3
Categorical

HIGH CORRELATION

Distinct	17
Distinct (%)	1.7%
Missing	0
Missing (%)	0.0%
Memory size	71.5 KiB

ATL	279
EC	222
DDT	141
TMKT	95
intercept	24
Other values (12)	239

Length

Max length	32
Median length	31
Mean length	8.174
Min length	2

Characters and Unicode

Total characters	8174
Distinct characters	32
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	ATL
2nd row	ATL
3rd row	ctrl_top5_market_share_std
4th row	ATL
5th row	EC

Common Values

Value	Count	Frequency (%)
ATL	279	27.9%
EC	222	22.2%
DDT	141	14.1%
TMKT	95	9.5%
intercept	24	2.4%
ctrl_own_brand_npd_std	24	2.4%
ctrl_macro_trscg_p_std	23	2.3%
ctrl_competitor_asp_std	21	2.1%
ctrl_competitor_total_sales_std	21	2.1%
ctrl_own_brand_discount_rate_std	21	2.1%
Other values (7)	129	12.9%

Length

Histogram of lengths of the category

Value	Count	Frequency (%)
atl	279	27.9%
ec	222	22.2%
ddt	141	14.1%
tmkt	95	9.5%
intercept	24	2.4%
ctrl_own_brand_npd_std	24	2.4%
ctrl_macro_trscg_p_std	23	2.3%
ctrl_own_brand_discount_rate_std	21	2.1%
yearly_seasonality	21	2.1%
ctrl_competitor_total_sales_std	21	2.1%
Other values (7)	129	12.9%

Most occurring characters

Value	Count	Frequency (%)
_	881	10.8%
t	804	9.8%
T	610	7.5%
r	527	6.4%
c	415	5.1%
s	405	5.0%
d	400	4.9%
o	395	4.8%
n	346	4.2%
l	340	4.2%
Other values (22)	3051	37.3%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	8174	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
_	881	10.8%
t	804	9.8%
T	610	7.5%
r	527	6.4%
c	415	5.1%
s	405	5.0%
d	400	4.9%
o	395	4.8%
n	346	4.2%
l	340	4.2%
Other values (22)	3051	37.3%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	8174	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
_	881	10.8%
t	804	9.8%
T	610	7.5%
r	527	6.4%
c	415	5.1%
s	405	5.0%
d	400	4.9%
o	395	4.8%
n	346	4.2%
l	340	4.2%
Other values (22)	3051	37.3%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	8174	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
_	881	10.8%
t	804	9.8%
T	610	7.5%
r	527	6.4%
c	415	5.1%
s	405	5.0%
d	400	4.9%
o	395	4.8%
n	346	4.2%
l	340	4.2%
Other values (22)	3051	37.3%

adstock_alpha
Real number (ℝ)

HIGH CORRELATION MISSING

Distinct	37
Distinct (%)	4.9%
Missing	245
Missing (%)	24.5%
Infinite	0
Infinite (%)	0.0%
Mean	0.34833728

Minimum	0.15208842
Maximum	0.5396742
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	15.6 KiB

Quantile statistics

Minimum	0.15208842
5-th percentile	0.19324492
Q1	0.25065067
median	0.36675043
Q3	0.44450253
95-th percentile	0.49995468
Maximum	0.5396742
Range	0.38758578
Interquartile range (IQR)	0.19385186

Descriptive statistics

Standard deviation	0.10223268
Coefficient of variation (CV)	0.29348763
Kurtosis	-1.1388407
Mean	0.34833728
Median Absolute Deviation (MAD)	0.10222627
Skewness	-0.03100824
Sum	262.99465
Variance	0.010451522
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=37)

Value	Count	Frequency (%)
0.4537456717	30	3.0%
0.2015771648	26	2.6%
0.4745182302	25	2.5%
0.3872391098	25	2.5%
0.3915610042	25	2.5%
0.1520884173	24	2.4%
0.4445617273	24	2.4%
0.246045076	23	2.3%
0.3360199254	23	2.3%
0.2506506721	23	2.3%
Other values (27)	507	50.7%
(Missing)	245	24.5%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0.1520884173	24	2.4%
0.1932449154	23	2.3%
0.2015771648	26	2.6%
0.246045076	23	2.3%
0.2483098525	19	1.9%
0.2485899787	19	1.9%
0.2489862168	15	1.5%
0.2503846768	20	2.0%
0.2506397608	15	1.5%
0.2506506721	23	2.3%

Value	Count	Frequency (%)
0.5396741956	16	1.6%
0.5000080459	20	2.0%
0.4999546848	17	1.7%
0.4982660608	21	2.1%
0.4745182302	25	2.5%
0.4689766964	16	1.6%
0.4627234416	18	1.8%
0.4537456717	30	3.0%
0.4445617273	24	2.4%
0.4445025317	16	1.6%

imme_contribution
Real number (ℝ)

HIGH CORRELATION MISSING ZEROS

Distinct	606
Distinct (%)	80.3%
Missing	245
Missing (%)	24.5%
Infinite	0
Infinite (%)	0.0%
Mean	117925.07

Minimum	0
Maximum	924824.17
Zeros	150
Zeros (%)	15.0%
Negative	0
Negative (%)	0.0%
Memory size	15.6 KiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	4005.9864
median	60861.875
Q3	140956.06
95-th percentile	455871.6
Maximum	924824.17
Range	924824.17
Interquartile range (IQR)	136950.07

Descriptive statistics

Standard deviation	169960.58
Coefficient of variation (CV)	1.4412591
Kurtosis	6.6604671
Mean	117925.07
Median Absolute Deviation (MAD)	60216.332
Skewness	2.435648
Sum	89033428
Variance	2.88866 × 10¹⁰
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	150	15.0%
22943.90215	1	0.1%
112756.8344	1	0.1%
540833.6415	1	0.1%
129603.7612	1	0.1%
53317.15336	1	0.1%
189017.3131	1	0.1%
74179.66534	1	0.1%
80298.0076	1	0.1%
71752.72372	1	0.1%
Other values (596)	596	59.6%
(Missing)	245	24.5%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	150	15.0%
25.79190899	1	0.1%
57.18438607	1	0.1%
86.63099075	1	0.1%
141.2170008	1	0.1%
176.2275872	1	0.1%
185.7806249	1	0.1%
210.2691828	1	0.1%
271.8212256	1	0.1%
337.8302293	1	0.1%

Value	Count	Frequency (%)
924824.1718	1	0.1%
916056.215	1	0.1%
915527.0636	1	0.1%
913569.1524	1	0.1%
898570.5718	1	0.1%
884261.0841	1	0.1%
875323.5006	1	0.1%
871766.4363	1	0.1%
865874.6424	1	0.1%
847648.4668	1	0.1%

carryover_contribution
Real number (ℝ)

HIGH CORRELATION MISSING ZEROS

Distinct	606
Distinct (%)	80.3%
Missing	245
Missing (%)	24.5%
Infinite	0
Infinite (%)	0.0%
Mean	74889.637

Minimum	0
Maximum	1084240.2
Zeros	150
Zeros (%)	15.0%
Negative	0
Negative (%)	0.0%
Memory size	15.6 KiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	1654.5677
median	25413.468
Q3	74356.498
95-th percentile	288096.47
Maximum	1084240.2
Range	1084240.2
Interquartile range (IQR)	72701.93

Descriptive statistics

Standard deviation	149080.22
Coefficient of variation (CV)	1.9906656
Kurtosis	23.442083
Mean	74889.637
Median Absolute Deviation (MAD)	25413.468
Skewness	4.416611
Sum	56541676
Variance	2.2224913 × 10¹⁰
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	150	15.0%
14499.58113	1	0.1%
37303.49378	1	0.1%
273699.2974	1	0.1%
42876.98502	1	0.1%
13460.93841	1	0.1%
120450.6669	1	0.1%
43577.24404	1	0.1%
41023.56776	1	0.1%
59601.3361	1	0.1%
Other values (596)	596	59.6%
(Missing)	245	24.5%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	150	15.0%
6.178027714	1	0.1%
24.96026014	1	0.1%
37.81333008	1	0.1%
46.64897199	1	0.1%
58.21420744	1	0.1%
69.45935097	1	0.1%
112.9946366	1	0.1%
142.0337012	1	0.1%
154.3185108	1	0.1%

Value	Count	Frequency (%)
1084240.197	1	0.1%
1073960.869	1	0.1%
1073340.506	1	0.1%
1071045.101	1	0.1%
1053461.149	1	0.1%
1036685.071	1	0.1%
1022036.666	1	0.1%
1015129.277	1	0.1%
987538.8271	1	0.1%
905705.3036	1	0.1%

saturation_lam
Real number (ℝ)

MISSING

Distinct	37
Distinct (%)	4.9%
Missing	245
Missing (%)	24.5%
Infinite	0
Infinite (%)	0.0%
Mean	2.0762712

Minimum	0.33421412
Maximum	6.0008514
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	15.6 KiB

Quantile statistics

Minimum	0.33421412
5-th percentile	0.66521806
Q1	1.3591955
median	1.8323941
Q3	2.3645662
95-th percentile	4.0138641
Maximum	6.0008514
Range	5.6666372
Interquartile range (IQR)	1.0053707

Descriptive statistics

Standard deviation	1.034103
Coefficient of variation (CV)	0.49805777
Kurtosis	3.2122727
Mean	2.0762712
Median Absolute Deviation (MAD)	0.498372
Skewness	1.5812987
Sum	1567.5847
Variance	1.069369
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=37)

Value	Count	Frequency (%)
2.377180623	30	3.0%
3.983940273	26	2.6%
1.832394135	25	2.5%
1.959947802	25	2.5%
1.579286762	25	2.5%
2.633878769	24	2.4%
1.288084619	24	2.4%
2.333510783	23	2.3%
1.598818577	23	2.3%
4.01386408	23	2.3%
Other values (27)	507	50.7%
(Missing)	245	24.5%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0.3342141249	20	2.0%
0.6652180642	19	1.9%
0.9844153854	15	1.5%
1.288084619	24	2.4%
1.323569041	15	1.5%
1.324214624	18	1.8%
1.326657245	21	2.1%
1.32713139	21	2.1%
1.334022131	20	2.0%
1.359195489	22	2.2%

Value	Count	Frequency (%)
6.000851374	15	1.5%
4.698029348	15	1.5%
4.01386408	23	2.3%
3.983940273	26	2.6%
3.334208432	19	1.9%
2.665447683	20	2.0%
2.633878769	24	2.4%
2.377180623	30	3.0%
2.364566237	23	2.3%
2.333510783	23	2.3%

saturation_beta
Real number (ℝ)

MISSING

Distinct	37
Distinct (%)	4.9%
Missing	245
Missing (%)	24.5%
Infinite	0
Infinite (%)	0.0%
Mean	0.011754277

Minimum	0.0015232275
Maximum	0.044895893
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	15.6 KiB

Quantile statistics

Minimum	0.0015232275
5-th percentile	0.0017965323
Q1	0.0047264541
median	0.0083888894
Q3	0.0140037
95-th percentile	0.035437178
Maximum	0.044895893
Range	0.043372666
Interquartile range (IQR)	0.0092772463

Descriptive statistics

Standard deviation	0.010048915
Coefficient of variation (CV)	0.8549156
Kurtosis	2.363903
Mean	0.011754277
Median Absolute Deviation (MAD)	0.0044960704
Skewness	1.6897087
Sum	8.8744794
Variance	0.00010098069
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=37)

Value	Count	Frequency (%)
0.01875606206	30	3.0%
0.003892819044	26	2.6%
0.02427601767	25	2.5%
0.00518681978	25	2.5%
0.009442132485	25	2.5%
0.004126222597	24	2.4%
0.006371321615	24	2.4%
0.008388889425	23	2.3%
0.03543717775	23	2.3%
0.003223064762	23	2.3%
Other values (27)	507	50.7%
(Missing)	245	24.5%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0.001523227534	15	1.5%
0.001715687929	15	1.5%
0.001796532264	20	2.0%
0.003223064762	23	2.3%
0.003244253067	16	1.6%
0.003460939638	19	1.9%
0.003892819044	26	2.6%
0.004126222597	24	2.4%
0.004571608604	20	2.0%
0.004726454074	19	1.9%

Value	Count	Frequency (%)
0.04489589319	16	1.6%
0.03921022512	21	2.1%
0.03543717775	23	2.3%
0.02427601767	25	2.5%
0.02416057794	23	2.3%
0.0203305953	15	1.5%
0.01875606206	30	3.0%
0.01566989691	20	2.0%
0.01400370033	22	2.2%
0.01355461115	16	1.6%

Auto

Heatmap
Table

	adstock_alpha	c0	c1	c2	c3	carryover_contribution	factors	imme_contribution	month	saturation_beta	saturation_lam	spend	total_contribution	year
adstock_alpha	1.000	0.670	0.679	0.679	0.679	0.169	0.982	-0.017	-0.012	0.329	-0.329	-0.121	0.055	0.000
c0	0.670	1.000	0.998	0.997	0.992	-0.068	0.976	-0.049	-0.031	0.086	-0.198	-0.294	0.262	0.000
c1	0.679	0.998	1.000	0.999	0.994	-0.035	0.978	0.060	-0.003	-0.370	0.240	0.211	-0.058	0.000
c2	0.679	0.997	0.999	1.000	0.995	-0.053	0.979	0.045	-0.030	-0.321	0.172	-0.098	0.225	0.000
c3	0.679	0.992	0.994	0.995	1.000	-0.053	0.984	0.045	-0.029	-0.321	0.172	-0.098	0.235	0.000
carryover_contribution	0.169	-0.068	-0.035	-0.053	-0.053	1.000	0.447	0.968	0.084	0.488	0.090	0.826	0.987	0.056
factors	0.982	0.976	0.978	0.979	0.984	0.447	1.000	0.138	-0.009	-0.380	0.273	0.248	0.057	0.000
imme_contribution	-0.017	-0.049	0.060	0.045	0.045	0.968	0.138	1.000	0.094	0.430	0.174	0.878	0.995	0.101
month	-0.012	-0.031	-0.003	-0.030	-0.029	0.084	-0.009	0.094	1.000	0.005	0.037	0.056	0.026	0.180
saturation_beta	0.329	0.086	-0.370	-0.321	-0.321	0.488	-0.380	0.430	0.005	1.000	-0.210	0.306	0.457	0.000
saturation_lam	-0.329	-0.198	0.240	0.172	0.172	0.090	0.273	0.174	0.037	-0.210	1.000	0.210	0.142	0.000
spend	-0.121	-0.294	0.211	-0.098	-0.098	0.826	0.248	0.878	0.056	0.306	0.210	1.000	0.587	0.038
total_contribution	0.055	0.262	-0.058	0.225	0.235	0.987	0.057	0.995	0.026	0.457	0.142	0.587	1.000	0.000
year	0.000	0.000	0.000	0.000	0.000	0.056	0.000	0.101	0.180	0.000	0.000	0.038	0.000	1.000

A simple visualization of nullity by column.

Nullity matrix is a data-dense display which lets you quickly visually pick out patterns in data completion.

The correlation heatmap measures nullity correlation: how strongly the presence or absence of one variable affects the presence of another.

First rows
Last rows

	date	factors	total_contribution	spend	year	month	source	c0	c1	c2	c3	adstock_alpha	imme_contribution	carryover_contribution	saturation_lam	saturation_beta
56	2021-05-01	atl_dy_kol_feeds_spend	0.000000e+00	0.000000	2021	5	Offline	Offline	ATL	ATL	ATL	0.462723	0.000000	0.000000	1.942170	0.008401
194	2024-03-01	atl_dy_kos_feeds_spend	2.565592e+04	0.000000	2024	3	Offline	Offline	ATL	ATL	ATL	0.387239	15720.943500	9934.975066	1.959948	0.005187
2185	2021-02-01	ctrl_top5_market_share_std	2.029070e+06	1.000000	2021	2	Offline	base_Offline	Base	control	ctrl_top5_market_share_std	NaN	NaN	NaN	NaN	NaN
233	2023-02-01	atl_dy_kos_spend	0.000000e+00	0.000000	2023	2	Offline	Offline	ATL	ATL	ATL	0.391561	0.000000	0.000000	1.579287	0.009442
1376	2023-01-01	ec_dy_expert_live_spend	1.873540e+04	103100.765642	2023	1	Offline	Offline	EC	EC	EC	0.152088	15885.962441	2849.437292	2.633879	0.004126
1847	2023-04-01	ec_tmart_cps_spend	2.762289e+04	90299.194534	2023	4	Offline	Offline	EC	EC	EC	0.248986	20745.172375	6877.719294	6.000851	0.001523
1567	2021-08-01	ec_jd_onsite_spend	1.982995e+05	757825.660000	2021	8	Offline	Offline	EC	EC	EC	0.246045	149508.886094	48790.616076	2.333511	0.008389
787	2021-08-01	tmkt_pg_st_spend	6.822831e+05	693750.000000	2021	8	Offline	Offline	TMKT	TMKT	TMKT	0.336020	453022.382655	229260.715875	1.598819	0.035437
2304	2022-05-01	ctrl_competitor_total_sales_std	4.454926e+06	0.862013	2022	5	Offline	base_Offline	Base	control	ctrl_competitor_total_sales_std	NaN	NaN	NaN	NaN	NaN
173	2022-06-01	atl_dy_kos_feeds_spend	0.000000e+00	0.000000	2022	6	Offline	Offline	ATL	ATL	ATL	0.387239	0.000000	0.000000	1.959948	0.005187

	date	factors	total_contribution	spend	year	month	source	c0	c1	c2	c3	adstock_alpha	imme_contribution	carryover_contribution	saturation_lam	saturation_beta
2016	2024-05-01	ctrl_macro_trscg_p_std	2.383578e+05	0.863747	2024	5	Offline	base_Offline	Base	control	ctrl_macro_trscg_p_std	NaN	NaN	NaN	NaN	NaN
2004	2023-05-01	ctrl_macro_trscg_p_std	2.298006e+05	0.832738	2023	5	Offline	base_Offline	Base	control	ctrl_macro_trscg_p_std	NaN	NaN	NaN	NaN	NaN
2211	2023-04-01	ctrl_top5_market_share_std	1.776970e+06	0.875756	2023	4	Offline	base_Offline	Base	control	ctrl_top5_market_share_std	NaN	NaN	NaN	NaN	NaN
1953	2023-06-01	ctrl_macro_cci_std	-9.882792e+05	0.680315	2023	6	Offline	base_Offline	Base	control	ctrl_macro_cci_std	NaN	NaN	NaN	NaN	NaN
1210	2022-03-01	ddt_hybrid_spend	0.000000e+00	0.000000	2022	3	Offline	Offline	DDT	DDT	DDT	0.375468	0.000000	0.000000	1.323569	0.001716
2147	2022-04-01	ctrl_own_brand_offline_wd_std	1.054894e+06	0.852410	2022	4	Offline	base_Offline	Base	control	ctrl_own_brand_offline_wd_std	NaN	NaN	NaN	NaN	NaN
191	2023-12-01	atl_dy_kos_feeds_spend	1.531897e+03	0.000000	2023	12	Offline	Offline	ATL	ATL	ATL	0.387239	938.686528	593.210404	1.959948	0.005187
1350	2025-03-01	ddt_sampling_spend	2.031509e+05	973169.600000	2025	3	Offline	Offline	DDT	DDT	DDT	0.338139	134457.624587	68693.254504	1.635413	0.013428
1124	2023-09-01	ddt_exhibition_spend	0.000000e+00	0.000000	2023	9	Offline	Offline	DDT	DDT	DDT	0.444562	0.000000	0.000000	1.288085	0.006371
2504	2021-09-01	intercept	4.160178e+07	NaN	2021	9	Offline	base_Offline	Base	intercept	intercept	NaN	NaN	NaN	NaN	NaN

Overview

Variables

Common Values

Length

Most occurring characters

Most occurring categories

Most frequent character per category

(unknown)

Most occurring scripts

Most frequent character per script

(unknown)

Most occurring blocks

Most frequent character per block

(unknown)

Common Values

Length

Common Values (Plot)

Most occurring characters

Most occurring categories

Most frequent character per category

(unknown)

Most occurring scripts

Most frequent character per script

(unknown)

Most occurring blocks

Most frequent character per block

(unknown)

Common Values

Length

Common Values (Plot)

Most occurring characters

Most occurring categories

Most frequent character per category

(unknown)

Most occurring scripts

Most frequent character per script

(unknown)

Most occurring blocks

Most frequent character per block

(unknown)

Common Values

Length

Common Values (Plot)

Most occurring characters

Most occurring categories

Most frequent character per category

(unknown)

Most occurring scripts

Most frequent character per script

(unknown)

Most occurring blocks

Most frequent character per block

(unknown)

Common Values

Length

Common Values (Plot)

Most occurring characters

Most occurring categories

Most frequent character per category

(unknown)

Most occurring scripts

Most frequent character per script

(unknown)

Most occurring blocks

Most frequent character per block

(unknown)

Common Values

Length

Common Values (Plot)

Most occurring characters

Most occurring categories

Most frequent character per category

(unknown)

Most occurring scripts

Most frequent character per script

(unknown)

Most occurring blocks

Most frequent character per block

(unknown)

Common Values